/*
Navicat SQL Server Data Transfer

Source Server         : 10.5.0.11(relo)
Source Server Version : 110000
Source Host           : 10.5.0.11:1433
Source Database       : relo24_tanky
Source Schema         : dbo

Target Server Type    : SQL Server
Target Server Version : 110000
File Encoding         : 65001

Date: 2012-10-10 10:49:18
*/


-- ----------------------------
-- Table structure for [dbo].[z_png_webform_location_city]
-- ----------------------------
/* DROP TABLE [dbo].[z_png_webform_location_city]
GO
CREATE TABLE [dbo].[z_png_webform_location_city] (
[country_code] nvarchar(20) NOT NULL ,
[country_name] nvarchar(120) NOT NULL ,
[city_name] nvarchar(120) NOT NULL 
)


GO */
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'AU', N'Australia & New Zealand', N'Acacia Ridge');

GO
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'AU', N'Australia & New Zealand', N'Payneham');

GO
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'AU', N'Australia & New Zealand', N'Berkeley Vale');

GO
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'AU', N'Australia & New Zealand', N'Clayton (Monash Bus Park)');

GO
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'AU', N'Australia & New Zealand', N'Scoresby');

GO
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'AU', N'Australia & New Zealand', N'Parramatta');

GO
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'AU', N'Australia & New Zealand', N'Perth');

GO
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'AU', N'Australia & New Zealand', N'Chemside Centre');

GO
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'AU', N'Australia & New Zealand', N'Ridleyton');

GO
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'AU', N'Australia & New Zealand', N'North Ryde');

GO
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'AU', N'Australia & New Zealand', N'Welshpool');

GO
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'AU', N'Australia & New Zealand', N'Sydney');

GO
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'AU', N'Australia & New Zealand', N'Melbourne');

GO
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'AU', N'Australia & New Zealand', N'Kent Town - South Australia');

GO
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'AU', N'Australia & New Zealand', N'Brisbane');

GO
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'AU', N'Australia & New Zealand', N'Subiaco - Western Australia');

GO
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'AU', N'Australia & New Zealand', N'Somersby - NSW');

GO
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'AU', N'Australia & New Zealand', N'Tasmania');

GO
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'AU', N'Australia & New Zealand', N'Queensland');

GO
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'AU', N'Australia & New Zealand', N'Townsville');

GO
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'AU', N'Australia & New Zealand', N'Auckland');

GO
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'AU', N'Australia & New Zealand', N'Palmerston');

GO
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'AU', N'Australia & New Zealand', N'Christchurch');

GO
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'AU', N'Australia & New Zealand', N'Wellington');


GO
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'AU', N'Australia & New Zealand', N'Ellerslie');

GO
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'AU', N'Australia & New Zealand', N'Others');
--------------------------------------------------------------------
GO
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'PL', N'Poland', N'Lodz');

GO
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'PL', N'Poland', N'Warsaw');

GO
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'PL', N'Poland', N'Sochaczew');

GO
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'PL', N'Poland', N'Lodzki');

GO
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'PL', N'Poland', N'Others');
--------------------------------------------------------------------------
GO
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CH', N'Switzerland', N'Zurich');

GO
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CH', N'Switzerland', N'Geneva');

GO
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CH', N'Switzerland', N'Basel');

GO
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'CH', N'Switzerland', N'Others');
-------------------------------------------------------

GO
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'ES', N'Spain', N'Madrid');

GO
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'ES', N'Spain', N'Mataro');

GO
INSERT INTO [dbo].[z_png_webform_location_city] ([country_code], [country_name], [city_name]) VALUES (N'ES', N'Spain', N'Others');
GO
